DROP TABLE IF EXISTS `book`;
CREATE TABLE `book` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `name` varchar(255) DEFAULT NULL,
    `dept_id` int(11),
    PRIMARY KEY (`id`)
) ;

BEGIN;
INSERT INTO `book` VALUES (1, 'lijz',1);
INSERT INTO `book` VALUES (2, 'lucy',1);
INSERT INTO `book` VALUES (3, 'bear',2);
INSERT INTO `book` VALUES (4, 'ok',3);
COMMIT;
